class CreatePlayers < ActiveRecord::Migration
  def self.up
     create_table :players, :primary_key => "player_id" do |table|
        table.column :first_name, :string, :null => false
        table.column :last_name, :string, :null => false
        table.column :rank_id, :integer, :null => false
        table.column :created_at, :date, :null => false
 #       table.column :PB, :integer, :default => 0, :null => false
 #       table.column :MB, :integer, :default => 0, :null => false
 #       table.column :RP, :integer, :default => 0, :null => false
      end          
  end

  def self.down
    drop_table :players
  end
end
